Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

Du måste logga in för att kunna göra inlägg i diskussioner.

Relaterade termer

Scoutmob
Software; Phone apps

An exceptionally well-designed and clever app (love the ...

Firefox 4
Software; Web browser

Mozilla's brand new web browser designed to compete head on ...

Evernote
Software; Productivity software

Evernote is a simple glassware that makes taking notes easy ...

OpenCart
Software; System software

Open Cart is a unique open source shopping cart system. It ...

Siri
Software; CRM applications

Siri (speech interpretation and recognition interface) is ...

LivingSocial
Software; Phone apps

Similar to Groupon, you can use this app to gain hand-held ...

Skapad av

Featured blossaries

payment in foreign trade

Kategori: Business   1 4 Terms

Best Beaches In The World

Kategori: Travel   1 10 Terms

Nikon Imaging Products

Kategori: Technology   2 7 Terms

HR

Kategori: Business   2 9 Terms

ALL ABOUT PRAYER

Kategori: Religion   1 1 Terms

Digital Marketing

Kategori: Business   1 6 Terms

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.   

Följ oss på: